1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Views
13 {
14 public partial class uctBan : UserControl
15 {
16 public uctBan()
17 {
18 InitializeComponent();
19 }
20 public static uctBan uctban = new uctBan();
21 int flag = 0;
22 private void uctBan_Load(object sender, EventArgs e)
23 {
24 HienThiDanhSachBan();
25 bingding();
26 dis_end(false);
27 }
28 void bingding()
29 {
30 txtIdBan.DataBindings.Clear();
31 txtIdBan.DataBindings.Add("Text", dgvDanhSachBan.DataSource, "IdBan");
32 //txtIdKhuVuc.DataBindings.Clear();
33 //txtIdKhuVuc.DataBindings.Add("Text", dgvDanhSachBan.DataSource, "IdKhuVuc");
34 txtTenBan.DataBindings.Clear();
35 txtTenBan.DataBindings.Add("Text", dgvDanhSachBan.DataSource, "TenBan");
36 txtDienGiaiBan.DataBindings.Clear();
37 txtDienGiaiBan.DataBindings.Add("Text", dgvDanhSachBan.DataSource, "DienGiai");
38 cmbTrangThaiBan.DataBindings.Clear();
39 cmbTrangThaiBan.DataBindings.Add("Text", dgvDanhSachBan.DataSource, "TrangThai");
40
41 }
42 void loadcontrol()
43 {
44 cmbTrangThaiBan.Items.Clear();
45 cmbTrangThaiBan.Items.Add("Bàn trống");
46 cmbTrangThaiBan.Items.Add("Bàn có khách");
47 cmbTenKhuVuc.DataSource = Models.KhuVucMod.FillDataSet_getTenKhuVuc().Tables[0];
48 cmbTenKhuVuc.DisplayMember = "TenKhuVuc";
49
50 }
51 void clearData()
52 {
53 txtIdBan.Text = Models.connection.ExcuteScalar(String.Format("select IdBan= dbo.fcgetIdBan()"));
54 txtTenBan.Text = "";
55 txtDienGiaiBan.Text = "";
56 loadcontrol();
57 }
58 void dis_end(bool e)
59 {
60 txtTenBan.Enabled = e;
61 cmbTenKhuVuc.Enabled = e;
62 txtDienGiaiBan.Enabled = e;
63 cmbTrangThaiBan.Enabled = e;
64 btnLuu.Enabled = e;
65 btnHuy.Enabled = e;
66 btnThemMoi.Enabled = !e;
67 btnXoa.Enabled = !e;
68 btnSua.Enabled = !e;
69 }
70 public void HienThiDanhSachBan()
71 {
72 dgvDanhSachBan.DataSource = Models.BanMod.FillDataSetBan().Tables[0];
73 dgvDanhSachBan.Dock = DockStyle.Fill;
74 dgvDanhSachBan.RowHeadersVisible = false;
75 dgvDanhSachBan.BorderStyle = BorderStyle.Fixed3D;
76 }
77
78 private void btnThemMoi_Click(object sender, EventArgs e)
79 {
80 flag = 0;
81 clearData();
82 dis_end(true);
83 }
84
85 private void btnHuy_Click(object sender, EventArgs e)
86 {
87 uctBan_Load(sender, e);
88 dis_end(false);
89 }
90
91 private void btnLuu_Click(object sender, EventArgs e)
92 {
93 string _idBan = "";
94 try
95 {
96 _idBan = txtIdBan.Text;
97 }
98 catch { }
99 string _tenKhuVuc = "";
100 try
101 {
102 _tenKhuVuc = cmbTenKhuVuc.Text;
103 }
104 catch { }
105 string _tenBan = "";
106 try
107 {
108 _tenBan = txtTenBan.Text;
109 }
110 catch { }
111 string _dienGiai = "";
112 try
113 {
114 _dienGiai = txtDienGiaiBan.Text;
115 }
116 catch { }
117 string _trangThai = "";
118 try
119 {
120 _trangThai = cmbTrangThaiBan.Text;
121 }
122 catch { }
123 if (flag == 0)
124 {
125
126
127 if (_tenBan == "")
128 MessageBox.Show("Hãy nhập tên bàn");
129 else
130 {
131 int i = 0;
132 i = Controllers.BanCtrl.InSertBan(_idBan, _tenKhuVuc, _tenBan, _dienGiai, _trangThai);
133 if (i > 0)
134 {
135 MessageBox.Show("Thêm mới thành công");
136 HienThiDanhSachBan();
137 }
138 else
139 MessageBox.Show("Thêm mới không thành công");
140 }
141 }
142 else
143 {
144 int i = 0;
145 i = Controllers.BanCtrl.UpdateBan(_idBan, _tenKhuVuc, _tenBan, _dienGiai, _trangThai);
146 if (i > 0)
147 {
148 MessageBox.Show(" Sửa thành công");
149 HienThiDanhSachBan();
150 uctBan_Load(sender, e);
151 }
152 else
153 MessageBox.Show("Sửa không thành công");
154 }
155 uctBan_Load(sender, e);
156 }
157
158 private void btnXoa_Click(object sender, EventArgs e)
159 {
160 string _idBan = "";
161 try
162 {
163 _idBan = txtIdBan.Text;
164 }
165 catch { }
166 DialogResult dr = MessageBox.Show("Bạn có chắc chắn xóa ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
167 if (dr == DialogResult.Yes)
168 {
169 int i = 0;
170 i = Controllers.BanCtrl.DeleteBan(_idBan);
171 if (i > 0)
172 {
173 MessageBox.Show(" Xóa thành công");
174 HienThiDanhSachBan();
175 uctBan_Load(sender, e);
176 }
177 else
178 MessageBox.Show("Xóa không thành công");
179 }
180 else
181 return;
182 }
183
184 private void btnSua_Click(object sender, EventArgs e)
185 {
186 flag = 1;
187 dis_end(true);
188 loadcontrol();
189 }
190
191 }
192 }